I have a requirement to qui<strong>C</strong>kly load a DataTable into an Ex<strong>C</strong>el sheet, where <strong>C</strong>ells should automati<strong>C</strong>ally format to <strong>C</strong>orrespond to the DataTable’s <strong>C</strong>olumn types. This is parti<strong>C</strong>ularly important for DateTime <strong>C</strong>olumns.
This work…...Select(c => c.ColumnName).ToArray(); public...altered; all other cell attributes (font, alignment, etc.) remain unchanged...